

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `user`
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` bigint(20) NOT NULL COMMENT '主键ID',
  `name` varchar(30) COLLATE utf8_bin DEFAULT NULL COMMENT '姓名',
  `age` int(11) DEFAULT NULL COMMENT '年龄',
  `email` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '邮箱',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
--  Records of `user`
-- ----------------------------
BEGIN;
INSERT INTO `user` VALUES ('1', 'Jone', '18', 'test1@baomidou.com'),
  ('2', 'Jack', '20', 'test2@baomidou.com'),
  ('3', 'Tom', '28', 'test3@baomidou.com'),
  ('4', 'Sandy', '21', 'test4@baomidou.com'),
  ('5', 'Billie', '24', 'test5@baomidou.com'),
  ('1143071308869120002', 'admin', '23', '946211284@qq.com');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
